/**
 * 
 *
 * Copyright (c) 2012-2013 JLLT Corp. 2012-2013,All Rights Reserved.
 * This software is published under the 金麟龙腾商贸有限公司.
 * License version 1.0, a copy of which has been included with this
 * distribution in the LICENSE.txt file. 
 *
 * @File name:  QuickOrderDao.java 
 * @Create on:  2012-07-22 12:29:555
 * @Author      :  陈伟
 *
 * @ChangeList
 * ---------------------------------------------------
 * Date         Editor              ChangeReasons
 *
 */

package com.boho.ecp.product.dao;

import java.sql.Connection;
import java.util.LinkedList;
import java.util.List;

import cn.boho.framework.po.CQuery;
import cn.boho.framework.po.CQueryFactoryTool;
import cn.boho.framework.po.DAO;

public class QuickOrderDao extends DAO {

	public static List queryQuickOrder(Connection con) throws Exception {
		List list = new LinkedList();
		StringBuffer sql = new StringBuffer();
		sql.append("select p.*, o.STAR, o.INFO from T_QUICK_ORDER o, T_PRODUCT p where o.PRODUCT_ID = p.PRODUCT_ID");
		sql.append(" and o.IS_VALID = 1 order by o.PRODUCT_NO");
		CQuery query = CQueryFactoryTool.createFactory().createCQuery();
		query.setCommand(sql.toString());
		list = query.getDynaBeanMapList("T_PRODUCT", con);
		return list;
	}

}
